﻿<?xml version="1.0" encoding="UTF-8"?>
<!-- oracle backup configuration Created: 08.2012 : Gunther Pippèrr (c) http://www.pipperr.de -->
<backup version="0.2">
	<!-- configuration of the asm environment -->
	<asm>
		<!-- set to true if ASM Option of the Database is in use -->
		<asm_in_use>false</asm_in_use>
		<asm_meta_info>true</asm_meta_info>
		<asm_backup_dest>d:\oracle\flash_recovery_area</asm_backup_dest>
		<!-- ASM instance SID - if RAC check for the NODE ID like +ASM1! -->
		<asm_instancesid>+ASM</asm_instancesid>
		<!-- if default - try to get from the oracle installation repository the location -->
		<asm_oracle_home>default</asm_oracle_home>  
	</asm>
	<!-- configuration of the grid environment -->
	<grid>
		<!-- set to true if RAC Option of the Database is in use -->
		<grid_in_use>false</grid_in_use>
		<backup_grid>true</backup_grid>
		<grid_backup_dest>d:\oracle\flash_recovery_area</grid_backup_dest>
		<!-- if default - try to get from the oracle installation repository the location -->
	<grid_oracle_home>default</grid_oracle_home>
	</grid>
	<!--- configuration of the db's to backup -->
	<db>
	<!-- DB Parameter -->
	<!-- Name of the database -->
	<dbname>gpi</dbname>
	<!-- SID of the database -->
	<sid>gpi</sid>
	<!-- Oracle Home of the databaes -->
	<oracle_home>d:\oracle\product\11.2.0.3\dbhome_1</oracle_home>
	
	<!-- how to connect to the database -->
	<nls_settings>
  
		<!-- if true use "/ as sysdba" to connect to the local instance -->
		<use_direct_connnect_for_sys>true</use_direct_connnect_for_sys>
  
		<!-- if false use the following nls and user settings ot connect to the database -->
		<tns_alias>gpi</tns_alias>
		
		<!-- if false use the following nls and user settings ot connect to the database -->
		<username password="mystempassword" encrypt="false" certificate="false">backupuser</username>
		
		<!-- Language of messages - charset like GERMAN_GERMANY.UTF8 -->
		<nls_lang>AMERICAN_AMERICA.UTF8</nls_lang>
		
		<!-- TNS_ADMIN -->
		<!-- if the value is "default" the Oracle Home Path is used, else the path -->
		<tns_admin>default</tns_admin>
		
	</nls_settings>

	<!-- Backup Database and Archivelogs -->
	<db_backup>true</db_backup>
	<!-- if db_backup_use_flash = true store only meta information and export in this location -->
	<db_backup_dest>d:\oracle\flash_recovery_area</db_backup_dest>
	<!-- if true - use the flash /fast recovery parameter as location for the backup , if false use parameter db_backup_dest -->
	<db_backup_use_flash>true</db_backup_use_flash>
	<!-- copy the complete flash recovery Areas to the location of the parameter db_backup_dest -->
	<backup_flash_to_disk>false</backup_flash_to_disk>
	<!-- Backup Policy - how many backups to store on disk -->
	<db_backup_count_of>1</db_backup_count_of>
	
	<!--IF EE Edition you can use the pattern to define the levels for each day (Day 1 = Monday, Day 7 = Sunday) -->
	<!-- 0,0,0,0,0,0,0 = every day one full backup -->
	<!-- 1,1,2,1,1,2,0 = only Sunday full backup  -->
	<db_backup_incremental_policy>0,0,0,0,0,0,0</db_backup_incremental_policy>
	
	<!-- if EE Edition parallel can be used 1-4 -->
	<db_backup_channels>1</db_backup_channels>
	
	<!-- if EE and BIG Table space portions if data for multiple channels parameter can be false or a value like 5000M  -->
	<db_backup_section_size>false</db_backup_section_size>
	
	
	<!-- if you like to use Backup Compression - typical in EE Edition! Check your licence!-->
	<db_backup_compress>false</db_backup_compress>

	<!-- Backup the Metainformation like the controlfile trace etc. -->
	<!-- attribute use_dot_net= false => use sqlplus and sql spool , true => use .net Dll to create csv file -->
	<!-- Oracle home for the DLL -->
	<!-- only possilbe if the tns Alias in the nls_setting / user / password Section is valid and use_direct_connnect_for_sys must be false ! -->
	<db_meta_info use_dot_net="false" dot_net_orcle_home="d:\oracle\product\11.2.0.3\client_64bit" >true</db_meta_info>

	<!-- check the Alert log for errors -->
	<!-- if listener_summary = true you get a list of connection to the database - not yet implemented! -->
	<!-- if attribute print_lines_after_match is set, you will see x lines after a match in the alert log in the result log -->
	<!-- if attribute use_adrci is true, ADRCI will be used to read the alertlog, if false the trace of the alertlog will be read directly -->
	<!-- to clean the log file use the runCleanLogfile.ps1 Script weekly -->
	<db_check_alert_log listner_summary="false" print_lines_after_match="7" use_adrci="true">true</db_check_alert_log>

	<!-- Parameter for the archive only backup -->
	<!-- if backup script is started with the parameter ARCHIVE - save only archivelogs if true-->
	<db_archive>true</db_archive>
	 <!-- if true - use the flash /fast recovery parameter as location for the backup , if false use parameter archive_backup_dest -->
	<archive_use_flash>true</archive_use_flash>
	<!-- Destination for the archivelog Backup if db default flash_recovery_area is not in use -->
	<archive_backup_dest>d:\oracle\flash_recovery_area</archive_backup_dest>
  
	<!-- Export the following users -->
	<db_user_export>
		<!-- if true do some exports  -->
		<export>true</export>
		<!-- if true the export will be zipped -->
		<compress_export>true</compress_export>
		<!-- datapump Export Directory -->
		<export_dir_db>export_dir_db</export_dir_db>
		<export_dir_os>d:\oracle\flash_recovery_area</export_dir_os>
		<!-- for each day of the week set a number, this number will be overwritten -->
		<export_policy>0,1,0,1,0,1,2</export_policy>
		<!-- the user to export -->
		<user>
			<!-- if encrypt=false the password will be encrypted with MS secure String , only readable on local machine -->
			<!-- if use_sys_account = false we will use the user account to export the data, if true use the nls_settings of the DB section -->
			<!-- filter not jet implemented - expdump filter to include/exclude objects -->
			<!-- tns_alias TNSnames.ora entry to connect to the database if use_sys_account = false -->
			<username filter="*" password="tiger" encrypt="false" use_sys_account="true" tns_alias="gpi" certificate="false" >scott</username>    
		</user>
	</db_user_export>
	</db>
	<!-- add the same DB section for the next database -->
	<!-- Extra File you like to copy to an other destination -->
	<files>
		<!-- if true copy the files -->
		<copyfiles>false</copyfiles>
		<!-- Pair of directories to copy with robocopy -->
		<pair>
			<source_dir>d:\oracle\flash_recovery_area</source_dir>
			<target_dir>c:\backup\flash_recovery_area</target_dir>
			<!-- Parameter for robocopy -->
			<robocopy_parameter><![CDATA[/S /W:0 /R:0 /NP]]></robocopy_parameter>
			<!-- delete files oder then x days from the backup location  999 do nothing-->
			<delete_old_files_days>999</delete_old_files_days>
		</pair>
		<!-- Pair of directories to copy with robocopy -->
		<pair>
			<source_dir>d:\scripts</source_dir>
			<target_dir>c:\backup\scripts</target_dir>
			<!-- Parameter for robocopy -->
			<robocopy_parameter><![CDATA[/S /W:0 /R:0 /NP]]></robocopy_parameter>
			<!-- delete files oder then x days from the backup location 999 do nothing -->
			<delete_old_files_days>999</delete_old_files_days>
		</pair>
	</files>  
</backup>
